﻿using System.Collections.Generic;
using com.huigo.Framework.Model;
using com.loto.Common.DBUtility;
namespace com.huigo.Framework.BLL
{
    public class CustType
    {
        public static List<Model.CustType> GetCustTypeDropList()
        {
            List<string> fields = new List<string>()
            {
                "TYPE_ID",
                "TYPE_NAME"
            };
            List<WhereStatement> whereList = new List<WhereStatement>()
            {
                new WhereStatement("TYPE_IS_ACTIVE","=",((int)Dict.IsActive.Yes).ToString(),"")
            };
            List<OrderByStatement> orderList = new List<OrderByStatement>()
            {
                new OrderByStatement("TYPE_NAME",true)
            };
            return SqlServerDal.CustType.GetItems(fields, whereList, orderList, null);
        }

    }
}
